SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454614 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454614 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599558,456019,680046,1008025,334042,156838,725968,299307,485346,74599,721582,462351,1026061,821748,234016,444195,889769,896172,781161,434206,150140,714750,975042,274209,57686,708710,638650,635076,750645,840443,633478,601360,553544,52100,149303,367096,369358,819453,720288,521657,639715,789566,181280,560716,420609,449348,486309,149617,829480,412946,495426,1030610,660383,21414,425754,28231,596660,774449,860678,661837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]