SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68573 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68573 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017229,984806,637582,980535,1019260,144329,449508,139507,585461,987015,61601,329692,624725,326266,352283,376059,283348,835425,892804,654425,722273,231177,999010,154752,547354,861713,635716,478436,685956,457828,361983,416812,769609,754262,947426,109842,82714,465397,688420,78497,470274,600921,12730,937945,649149,975383,154191,610674,718937,665774,210028,220152,970092,825697,676947,643401,754006,991896,774870,174892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]