SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021960 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021960 [ RunTime:0.002057s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286653,23356,527680,201899,785080,74054,802576,649471,793135,250514,611918,1016873,136870,599424,237204,1024851,924797,943001,978099,222737,215580,748499,776930,311923,454650,941956,159847,904758,401440,722142,255392,446878,597998,451680,751575,584264,172415,671727,153207,667019,249725,159984,140539,808165,852091,1014025,308286,624435,577323,307970,40876,839590,975685,814706,75162,366761,247683,1030680,558417,603398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]