SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417993 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417993 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953530,1045989,343462,68143,198626,187666,529319,1005216,822011,726438,768235,475755,430792,670220,234383,887454,64850,337348,776316,147475,566936,153792,944951,919044,721939,885857,447664,780004,568522,988181,573143,1043545,131667,930870,403613,928263,845452,564171,414895,267602,14019,280004,353099,131899,848694,21078,789091,458116,461077,560491,34303,900304,493808,693972,268609,783157,45838,104260,368690,275956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]