SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018398 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018398 [ RunTime:0.002086s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889484,666358,1021809,445630,751956,841181,30617,704495,744786,289685,196401,841419,809763,634031,593055,279364,193369,411473,309841,884936,843349,574548,694376,812292,195512,822608,672686,422525,17734,327542,144065,971853,1039654,841496,663529,539750,320355,932678,893754,163803,475993,108841,598583,562680,499193,185140,551883,1039004,745973,118647,680166,508975,195839,558396,922287,505469,813737,399765,746879,86095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]