SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001929s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413009 LIMIT 1 [ RunTime:0.001548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413009 [ RunTime:0.003664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432468,924187,135236,822786,343150,74565,1046874,245069,64798,319827,120778,982826,30269,344936,767623,281849,788991,347549,40270,981390,735934,120357,1028189,467040,705617,517692,52915,803001,694284,323064,270331,255639,327761,20574,1032451,128876,343797,689411,1004840,212056,627337,849811,261224,1004020,283586,1013288,947042,1033279,76738,812206,669496,83029,483218,946881,488931,220981,418000,490469,983908,255303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000904s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003558s ]