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` = 433897 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433897 [ RunTime:0.003004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318677,231249,1042590,1024230,520794,476640,847365,400838,788960,15346,198604,436556,871166,370709,44637,395936,788649,132466,849814,885867,37864,429191,618693,104987,505874,96040,416162,636936,479078,912143,1013769,717691,414923,847035,562573,126886,1024567,795644,641365,314891,545496,774291,886777,223411,385853,1029257,403873,970755,227752,697063,295674,455693,1394,432873,634749,238511,1006966,577619,850802,801520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]