SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020059 LIMIT 1 [ RunTime:0.004532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020059 [ RunTime:0.007895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274886,1037533,532299,957106,751621,660234,734590,212132,699131,604951,132011,710509,270643,178397,739704,250028,1031693,913515,386252,315413,172092,925228,270617,423360,612448,784599,852742,735821,468023,904106,864862,398527,169906,777917,1016060,908568,327197,503369,91156,227289,352727,173874,810006,390920,849206,976403,649076,290980,246463,806811,376671,228571,576305,800270,1224,620213,477325,441704,416641,302610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]