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` = 584344 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584344 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300665,617926,983993,74778,653644,308603,381135,101634,168622,437889,669914,834477,6064,64053,456298,393757,676883,583836,104201,360826,182010,740790,557139,138821,825911,91003,167181,226176,213772,113117,132408,278767,26002,796522,700548,933092,139240,240299,842051,393560,816549,1006249,1012194,789998,765991,9341,216394,803414,886726,333656,306071,231709,177266,478826,333973,340538,655387,294830,1012763,555064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]