SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336428 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336428 [ RunTime:0.002559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446678,126386,743453,1021826,161103,1046495,496797,421026,920304,201787,444561,86928,840531,642666,165017,517358,792150,238973,550508,386546,687700,511365,64379,963276,364844,256360,1007466,102155,1013636,276307,284871,896474,231377,285119,128226,374239,379320,2800,386792,620202,22044,604472,851793,540558,428277,637339,1004658,632626,747805,27525,580724,791463,51573,296800,227458,284653,112215,679966,972467,237767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]