SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001745s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004133 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004133 [ RunTime:0.002385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170871,577088,595731,354959,933073,344096,496648,285928,186246,195823,408049,348978,882232,34645,58225,538287,393562,1011480,954232,834617,896426,178151,586572,889993,331345,474557,862328,999208,619353,136761,734151,950554,761145,489830,9931,435684,195064,892027,515880,27260,718013,640660,630277,585050,996374,108868,252142,272474,920126,243912,887296,538345,161591,129580,319083,617757,163234,233955,433478,673251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]