SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001800s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022091 LIMIT 1 [ RunTime:0.000671s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022091 [ RunTime:0.001480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032293,84787,941923,42979,867017,238645,236083,510466,63716,426793,1014732,911534,909815,573028,351477,98714,326052,364807,128999,768026,810225,927010,221885,840162,612167,239842,937460,134288,101137,687339,507146,720329,553621,63078,584523,953527,663193,1009976,387663,737532,20119,36803,777969,336825,426017,48987,578759,144535,922180,1046235,821871,740806,322136,60848,3760,779118,130927,937007,438031,387582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]