SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405761 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405761 [ RunTime:0.002785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381998,138328,262109,240387,462939,956764,1005852,385164,402442,454737,669246,514095,661857,381506,858253,776004,682451,797572,173408,935746,490403,562301,2838,641544,694468,239027,41781,853359,991445,819513,1033355,335625,897609,105540,787686,781891,103540,406253,625358,730448,138184,870758,744755,1005984,145573,421627,805474,431916,837866,785438,840740,936819,195436,196686,181616,746369,329796,768917,184266,939801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405761 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405761 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]