SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455406 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455406 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156294,164875,984662,765467,900714,331131,723558,371860,966777,928006,302624,215514,350520,836848,377874,76196,742781,627948,409879,702824,129696,715162,779594,1013016,341334,310019,928231,345029,402920,383680,367497,800776,866477,971345,221529,916608,414333,764578,388286,966069,638615,129832,342973,304273,435447,318368,768746,540421,430031,234031,720698,496535,558290,866091,603829,649822,101950,864921,47398,881583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]