SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428910 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428910 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930373,532622,914660,996570,986087,647724,671504,499902,1020729,543759,28854,970615,811762,660401,20049,202100,553697,363739,352998,755078,578407,281107,233760,969169,343769,729126,396301,594145,204961,514741,207390,836534,57580,679752,656865,944463,651951,186244,533422,244815,975154,994864,467110,469208,343448,445140,752430,510098,55264,428936,547474,155820,885550,697919,324246,377580,261948,60149,243810,1001390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]