SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305395 LIMIT 1 [ RunTime:0.001140s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305395 [ RunTime:0.004800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988544,25502,690834,521464,253591,122618,568185,709572,539539,627972,502708,378903,409819,273458,110337,49524,402505,242619,400283,379019,1016890,633052,923214,426992,910823,426134,120718,926281,701935,536641,257229,291964,332266,316891,550353,904218,224404,631513,586978,704121,798012,135140,48681,698691,508744,683288,364297,325825,465161,878707,538853,902404,132012,947309,193119,729407,557070,695028,191582,62279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305395 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305395 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]