SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001558s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344180 LIMIT 1 [ RunTime:0.003355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344180 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481646,132889,886584,315995,226802,3064,1028552,937731,999076,887398,489579,101768,39843,709654,1048415,751789,758860,201003,545539,593507,954709,626288,233122,361603,194111,554204,9087,143614,901601,133082,938133,665409,738233,27448,583486,875068,1038758,454183,46342,600130,693413,457496,208625,79060,829717,598364,995203,547810,581431,201578,525403,181912,991317,85602,98185,495262,545274,703460,823226,340294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018671s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001520s ]