SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498503 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498503 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5214,137878,808534,83171,621095,178540,465817,186785,358993,801340,382773,68643,611866,905644,180134,731643,858039,190964,526573,120371,421018,367366,638884,762782,586100,503044,220440,657097,347516,849775,459416,514749,352992,628090,636592,1015727,609466,709104,655401,216292,50048,636077,242761,73000,1048691,312208,775359,813515,606825,527396,941757,1045464,419998,674234,865911,135482,819056,1009495,901198,745746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]