SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313694 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313694 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939036,1004763,501348,307850,568793,640221,653210,859058,50019,551059,759732,890657,111654,137739,793830,972959,292090,985798,162985,762174,739109,370986,681679,132009,305192,774118,555433,836842,62782,63799,1017867,602356,742396,243104,762079,901451,632001,467066,500149,968446,852326,649808,195292,854910,25050,668245,886734,478898,689908,999476,640802,379951,830296,52907,109046,571609,442691,162027,487796,565753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]