SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498320 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498320 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775711,490759,843615,639754,529632,743045,1032933,10071,521311,224516,1032086,963320,830829,60957,626899,516359,915670,679920,17505,14835,939165,569924,409591,778338,332453,93949,276755,392393,667027,1032396,1043538,97332,171293,780815,332206,608463,1005206,1042579,881744,191188,848338,578330,694840,244290,223330,1025310,559137,160881,377621,62692,284605,615304,716620,94328,694013,677168,988245,943533,485625,349308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]