SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 614473 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 614473 [ RunTime:0.003707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514100,109530,803068,443940,78601,131759,807030,979439,187958,254695,405825,851830,540881,480911,721532,75636,160770,178010,316945,353809,402604,394090,827026,410594,542081,191723,950595,551910,92859,338589,207795,576860,180929,197465,610586,169633,854985,500964,27137,794464,769824,1017228,200996,132571,562627,902725,747122,68834,338672,545230,650744,798252,635983,288011,1004144,167564,588893,511573,401017,397792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001749s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 614473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 614473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]