SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563870 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563870 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132483,277211,470480,603045,130804,1018821,891194,744424,801058,219380,642746,103934,625843,895996,677800,819078,271243,482982,485576,220958,310728,470097,542580,753074,11395,823853,257316,257204,322737,50412,709651,816669,319307,497745,871882,865164,854282,179181,303054,411773,936015,473240,364768,49183,962054,576067,877257,343717,376252,939493,157042,723253,947532,12980,249666,378482,990594,148068,306607,580381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]