SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019851 LIMIT 1 [ RunTime:0.000938s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019851 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767020,798990,645414,730566,986190,481044,171374,91978,669822,824710,293389,556820,267892,159897,347352,207081,621761,37083,440721,1005614,69876,221337,797066,301537,355415,440853,561055,456973,614174,849019,413614,9044,840652,898782,713556,470681,780463,712632,523052,45778,278895,475290,1018888,255672,951261,935143,569919,16720,570957,94073,619319,394108,202517,180459,871676,289730,77568,203361,842749,651857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001745s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]