SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028508 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028508 [ RunTime:0.001489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954796,255106,764939,496798,187866,344915,5098,818902,488439,860367,256902,165172,620744,847205,920269,25807,843175,196353,537609,218011,996876,436700,615353,422088,403773,496325,519729,740941,388214,492507,480157,647132,85029,770445,171078,444399,60705,635620,622652,883613,1000227,859051,866227,268891,75748,905107,552908,133305,137509,922010,115848,989202,30714,886022,79121,717711,537413,553045,895725,1007644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001228s ]