SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 918083 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 918083 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497520,346566,386996,395325,540639,167552,582539,1036296,10608,63615,776626,392473,55328,178308,684267,10125,577408,201387,512063,64910,872291,233648,923355,925368,175659,618208,469074,943187,967998,407813,81284,927030,461506,311397,585866,907443,285508,66265,158456,943705,293380,956542,303472,1006178,455997,22400,805927,955720,648071,519821,967145,372078,287714,1009078,19143,661842,311783,1048759,461570,689490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 918083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 918083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]