SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110414 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110414 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813728,960567,474709,1039903,861814,537706,42578,1006923,105597,885230,738365,375161,873467,407740,837973,713649,38755,298319,851238,1015454,806034,61142,997952,188074,106351,391472,1026041,883750,424188,718739,782010,439830,939205,477140,662639,199044,247301,253423,943797,541742,302149,14121,774038,995016,96995,919732,527888,218932,264738,928091,207862,473989,302512,835226,811755,212888,275127,91148,481328,349150) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]