SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553810 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553810 [ RunTime:0.002459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103806,83521,799604,735100,846078,117461,28674,193044,879468,401111,318124,625685,1017983,587783,650210,897419,45428,816356,626614,813370,509059,507305,445086,324054,575013,406802,321677,580979,293762,602068,674679,342876,941323,876581,586248,703884,504859,984165,698299,788905,190119,264313,415067,30570,834517,318628,277073,682882,938630,465724,175604,668367,690240,603279,134639,9314,706936,774890,959516,676520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000842s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001340s ]