SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 376245 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 376245 [ RunTime:0.003025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104985,1016547,549001,851284,4842,802524,82838,512372,648263,893644,1029067,417139,1030880,841707,33773,72871,317480,627341,275332,657820,68955,26305,704919,666487,171113,910864,404317,176771,527286,647503,636839,931915,540321,685293,102750,34021,990464,31747,249145,630650,990840,519012,104835,615485,184069,35028,464440,64047,479600,265708,687622,144582,253428,69625,427189,309896,5873,44450,720920,824076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 376245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 376245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]