SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298244 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298244 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423847,539315,88056,1027743,950735,809200,336196,435012,812712,338094,459614,536440,555561,941180,735332,163163,86349,107736,118985,642405,561054,551055,775661,158864,708995,633950,505064,399717,143135,203543,417252,28756,994584,519769,401400,494319,581404,540594,112565,56628,1041033,494318,74212,672524,281991,913745,760277,89970,267214,441542,148398,523498,552617,747811,676899,307012,817330,600706,783218,845988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]