SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803381 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803381 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20139,892236,682428,878935,412407,753420,836833,842651,973926,116362,298353,648693,1031562,51319,242950,12854,893795,417852,252309,998057,557166,271081,185419,132158,718535,424938,266378,151025,600469,786978,6524,796693,813692,358170,314657,961806,576873,366116,479127,652906,233074,428561,743819,903479,939090,755558,762267,201397,664048,665220,9526,113243,620330,480242,662398,667711,770141,51645,225888,586052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000827s ]