SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541694 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541694 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721122,318026,506726,555878,536373,721799,208739,304541,848714,767091,1018047,561301,226684,816039,379310,515791,711152,303632,925962,150182,914967,309790,781142,602860,255298,528625,63044,737623,1028143,309457,361661,855231,108374,438666,880501,1012066,665212,735898,197353,587775,865085,8055,206797,987692,167251,316430,719293,694817,174494,707936,2914,667039,600854,766506,802661,999869,381059,843925,784525,960486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]