SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414293 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414293 [ RunTime:0.004192s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739921,703448,500125,541923,241452,928122,2743,270079,185563,612111,729370,861720,872660,886336,209990,53810,233211,167418,103009,144544,973537,509419,347364,284231,681067,773573,411837,1027532,361983,947422,851088,965491,657014,676495,878374,40650,238901,428859,620076,396453,1026256,1047466,137418,172085,654983,666091,798756,203820,840277,22171,950211,434065,478855,135137,967757,753713,348623,699303,228147,197566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]