SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503408 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503408 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (867600,266294,554324,935970,975215,619668,85509,66204,200031,947979,191565,15158,603599,159225,945955,747934,768139,989789,661676,288838,369779,803632,230155,145400,268122,377989,774388,276367,381980,441749,323534,1003777,449694,892361,54842,768315,40624,50884,849357,2197,913334,225909,121574,70279,120923,570940,199120,435043,513470,653070,665976,273922,100743,717786,19010,651072,105143,818135,656247,1038916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]