SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41701 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41701 [ RunTime:0.002348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125023,1001640,697784,910047,459267,541322,575663,306365,486446,37365,883314,371375,381872,913886,578184,825062,394698,462648,557639,511822,538865,814237,597370,152571,260334,908657,348695,357314,222300,793973,247665,213282,993590,939110,215490,744340,307061,957687,61918,614905,752052,949279,50178,750814,714512,77631,747425,32340,990711,51103,190706,471117,923350,591061,456824,58017,156915,618746,624320,336397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]