SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 729841 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 729841 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125628,479504,201993,874273,197566,648092,533655,429765,770310,129243,662370,535618,545622,385483,351168,534694,605620,309500,881442,504515,316980,380975,477162,117497,959727,1040504,832867,314162,204901,348717,176600,462814,967930,791240,924378,579956,105443,807109,264818,229003,16813,349150,495339,894939,414175,846643,1047966,563108,605975,1010750,77103,531659,670846,876032,225896,1039136,215007,448001,614406,936685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 729841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 729841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]