SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981013 LIMIT 1 [ RunTime:0.000875s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981013 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47271,513731,121670,666429,1001282,498903,757933,962928,13606,294915,993232,1008004,832203,1025666,592835,1010043,33700,538704,599295,629106,844829,426562,64955,588205,840288,40942,645696,1031410,664048,111229,504546,667034,766531,110961,712723,451402,473918,29105,774732,21824,349249,510512,246146,273140,891613,960687,810336,919778,445658,658324,248540,747319,72035,272852,524696,455059,420175,629550,904379,26069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]