SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564703 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564703 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615281,358691,797644,634792,427529,977429,491631,666156,428059,472877,586526,536064,896258,231342,448569,627698,982301,742244,378797,376307,840853,329433,298373,391519,86246,453557,325799,88425,961306,59685,331075,41031,956180,920832,545414,296206,783108,366885,907043,448974,589349,53798,1018453,418817,743969,622021,785230,686609,296514,598526,675606,487394,491928,581905,469466,653750,649989,892044,838186,803541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]