SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412312 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412312 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457282,78631,1039222,710314,821611,277462,570209,291767,766885,144499,970931,833766,844606,767365,390661,155416,237493,393003,1026100,986683,163542,170258,232107,135803,810541,174066,233292,782983,171266,464355,535384,177600,451135,164562,973092,130127,584406,1045722,244026,1013709,203169,334035,435657,397609,73812,938311,557447,226804,390791,247385,128605,653930,696789,564545,73694,517547,252828,694856,462878,873997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000858s ]