SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563570 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563570 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754035,484799,324480,677024,920198,1040300,98105,176750,292329,277992,662311,634722,174773,641015,914802,74522,811437,686830,289206,205807,442068,701778,199209,248084,264499,891282,910146,597386,712370,380885,928939,118864,257499,175755,74221,705590,629879,337698,416597,97168,711420,181195,323082,1043971,290260,497640,620005,164831,73959,657542,1031008,749143,617743,1040256,86274,789973,995576,641179,245027,489276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]