SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42518 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42518 [ RunTime:0.004737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425768,425066,52401,827967,348209,99677,72099,335888,143987,540975,309595,727922,835919,1031998,390595,1044994,961501,598104,230794,583971,91383,385627,333093,1040357,1008808,779180,392757,993162,424979,50033,562890,88305,1752,286501,629085,485534,1025851,160461,640574,368564,971287,37065,874673,426275,216518,890567,1027739,263308,558938,721488,86774,571271,223871,461363,451504,376798,452820,282302,99228,558064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]