SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540913 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540913 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353847,941036,328575,628951,604962,479778,280226,100559,957177,53634,1010625,695696,695549,889688,983550,928962,499859,778199,797304,776004,1045198,20769,331693,48828,403541,714234,851094,524734,397075,64082,84615,805300,692546,818803,91870,484554,899435,369259,253609,400347,315901,540806,33445,464079,43080,739266,248035,718553,957628,1000555,879416,606865,993606,893665,855518,726094,1032064,4548,772235,976192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]