SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320153 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320153 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92098,344061,248202,576797,594043,10317,727341,228493,12745,760488,207548,464762,338838,777878,201826,474742,500904,903023,149656,615427,819084,11789,251200,315827,276028,796955,999781,8296,160095,240273,37251,84941,919553,728649,456818,501536,789736,116379,518229,483611,529000,952707,638642,812729,1036895,789819,60211,965752,1041509,533098,169300,290306,163246,683748,558302,276166,927097,905640,91990,985043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002432s ]