SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036318 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036318 [ RunTime:0.003833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560700,749141,906229,331766,785476,736413,401393,65038,972631,629533,90432,191205,272298,681628,757320,979331,107976,471706,605788,1017721,566826,896035,666369,235281,2710,358069,430912,821281,728347,627026,340137,560293,1026442,200435,669259,1011190,1015,370437,462021,243736,220435,123523,826092,426999,149153,993843,633490,627374,863826,870695,420004,471209,1008354,869828,311699,455590,266687,883592,883579,561158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]