SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527654 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527654 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483510,855974,671393,889259,702254,1019008,45934,737365,831028,35388,953094,70702,854277,263661,150440,115778,285309,729587,1013640,988095,677043,114611,532379,39454,1033829,66220,626501,20888,290264,639654,589053,684769,871765,118405,766428,178088,8951,595638,392745,997742,354535,177655,699583,341090,49864,980551,125698,656166,651912,67074,113042,224973,1010646,447816,421660,240601,419380,194955,1035557,297062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]