SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017319 LIMIT 1 [ RunTime:0.001259s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017319 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853613,718746,157485,675408,115594,922598,416552,849258,727144,201286,221036,417882,415165,55845,297751,1012008,301747,706464,891694,490431,192197,398730,148692,124663,490253,83827,254765,91738,333715,548441,525275,607387,85000,901696,870908,35613,271559,947589,202026,41273,483831,709753,706320,425894,397416,679708,695198,441604,554187,311860,51887,302883,972295,498147,510285,411348,881084,233899,866441,421492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003125s ]