SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39170 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39170 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663304,387972,413766,129185,280059,349963,807518,250329,411517,286661,159645,219628,894645,127545,218295,665057,50707,814535,79671,971331,260307,672323,275164,1023254,342200,945076,101635,812591,746518,140226,213451,526833,11284,700507,365760,748719,202694,256064,14499,600243,932234,779153,202726,1048349,153017,336757,427642,30883,756839,93364,450212,431085,301385,1036457,227905,793867,413773,311420,561335,830619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]