SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001779s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045219 LIMIT 1 [ RunTime:0.000630s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045219 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022754,540464,957305,453369,985866,135663,919753,483326,231179,225372,361728,19487,407672,629840,490936,152856,837723,214258,379653,86029,210434,472516,358343,708196,856045,483358,175400,860840,501789,540988,138915,473157,516146,767171,41277,153108,331864,721978,20832,572692,186650,922943,933479,611510,217711,387989,630712,257009,951612,665784,207797,521485,773029,645966,62895,876577,760375,326660,910050,73772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001575s ]