SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410002 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410002 [ RunTime:0.002077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003350,38338,156533,975176,955877,918914,627597,519811,549641,998786,699174,416699,398430,112864,533695,830214,635211,335542,233504,747557,764749,474837,134524,19643,1005007,96718,14487,226862,464627,1035482,785966,980024,985131,659537,278385,622752,669463,986848,927203,591032,365145,796303,964758,947685,180697,365099,35628,1008042,456180,152093,957670,919122,793090,801365,139815,115405,440599,30012,636250,1006383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]