SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570501 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570501 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734152,910806,987952,96693,969209,623611,920357,551721,771490,869701,540498,819728,691658,729298,500109,923967,920094,334368,448748,850968,374818,655405,31344,239775,1045973,836938,665730,231162,129170,981031,558080,656259,825648,813195,598040,1048084,433428,35257,631438,668659,964719,181251,914872,407339,438827,209869,1027994,1029364,758989,975003,979340,926813,968803,664230,862728,584343,666520,608013,380079,943485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]