SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001512 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001512 [ RunTime:0.003017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517368,540721,498470,802689,465769,61544,219771,638654,566502,226658,117343,232466,433815,263574,199769,607434,820836,90018,647358,5724,251974,114184,942433,49942,63016,556992,641840,625851,372919,55983,872951,811086,919149,53752,7959,32056,70234,844825,308029,639966,1036716,570830,920039,429777,873290,24636,12313,656046,828522,697972,1029188,59620,333587,340269,960311,964275,169938,407647,810287,106165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]