SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020670 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020670 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682939,29243,1046545,683865,108106,791192,390508,186319,620112,312105,93448,800508,642582,372480,209785,653773,636056,864059,673410,755107,66783,724172,181183,207199,1026203,294399,199734,841630,610862,937859,651281,966474,631668,301420,302723,534377,145195,545577,329162,878843,22601,855123,512293,56297,599535,238604,802325,160636,490877,969192,710522,47125,349785,235813,599716,563542,995683,568746,228515,1029796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]