SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457821 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457821 [ RunTime:0.002098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632145,707048,794351,38973,560913,627947,550019,520529,889204,903378,656394,470467,743605,803467,896675,986211,280508,781074,588670,238667,1016947,382005,691966,1002185,375964,947327,140889,26334,305880,398312,846707,331806,958025,896493,513181,107410,847145,1035886,149858,951653,28569,677048,133241,375097,289308,237072,75594,49670,590685,548788,722892,505294,625118,1024237,1015430,801679,670868,542961,923812,51129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]