SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562523 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562523 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317863,410242,363431,956829,161630,544595,482718,1012333,192758,125768,1033414,1018727,253595,978016,311406,250646,577081,474947,301726,972214,12725,718824,223216,870020,34747,773239,139089,950795,304733,671329,28613,877069,230488,52847,706887,1033986,349996,991266,713086,894425,384898,184960,652698,472102,182475,582505,114726,716096,251670,898878,748347,931866,430836,877428,652773,611713,94980,951180,1035751,722147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002390s ]