SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 71320 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 71320 [ RunTime:0.002498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015953,37667,212544,975714,863740,258874,457536,446912,249257,1014262,282888,837940,839640,155735,577239,908779,184143,655185,508053,632273,558336,505652,347366,694453,570989,723843,642412,771888,992577,105908,17727,916689,198708,159863,29132,880472,291280,118086,266368,12810,387770,1595,845879,590039,116926,463671,739748,724536,77512,189551,109662,466507,769479,320842,23382,213444,507328,98557,847680,641508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 71320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 71320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]