SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4766 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4766 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039552,1009719,836833,662476,841606,103436,801998,379917,85643,785253,530007,329790,345902,22149,592360,669937,636523,675654,589600,600478,17191,270253,823718,288099,253348,850486,893719,917957,958578,984162,939926,352404,2597,949764,290722,940942,344154,728290,427866,277422,719527,1039741,753607,877520,45837,1030797,540583,622092,64258,658437,270773,531669,927904,818163,797446,371913,331440,412438,874276,459075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]