SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001810s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514416 LIMIT 1 [ RunTime:0.000852s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514416 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603242,210686,675219,787398,561475,128362,937566,369159,617355,1044138,903393,692499,623399,98653,718761,896643,478064,367615,779228,102220,539770,203390,309964,840548,67116,158335,519269,423100,10596,580027,319113,252932,735280,342644,290685,739648,496115,211523,356930,466728,653856,792317,257046,447419,764198,378973,434763,295474,911470,772604,460948,657797,278980,122063,286593,580078,738373,662794,384518,881244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]