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` = 140070 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140070 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495032,818308,889430,500382,1015612,220266,770709,599852,28419,39643,470107,286553,663664,733490,202265,920479,454808,650270,1473,1001801,436112,843496,1046706,710039,246801,131404,957964,440007,575133,245171,401715,235263,966191,814399,521330,222496,308050,172573,127266,831500,312512,65622,21908,336464,971045,686995,713820,1022865,235598,176380,91305,159202,95619,868631,779105,677086,179929,415701,440616,937335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]