SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543585 LIMIT 1 [ RunTime:0.000858s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543585 [ RunTime:0.005949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126132,877619,341254,871907,745237,546007,134480,554817,956,619496,314095,24990,747396,262234,702192,872892,496506,479854,144109,957407,835559,540881,638226,185434,730374,355467,935169,400110,151624,769542,759668,253001,1046146,1043983,671747,65899,276436,1013057,10454,1015084,84742,449622,424420,595749,1014561,180271,1010257,777536,495863,601790,883499,386093,737340,1044903,468190,744385,798130,940836,1007990,369028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]