SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001551s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045024 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045024 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036648,291747,929961,409352,29324,852776,717361,339558,385869,823565,242300,282580,466314,650296,256235,676661,258730,210161,806285,463541,708795,920286,447794,521558,275174,508275,564610,827997,1012323,477127,225679,1035219,245767,261898,846920,434017,374453,361858,808831,70487,480187,38899,455316,162844,847316,340230,751004,303114,236881,216509,579987,1020089,734385,928831,354510,713570,593681,871915,326461,853858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]