SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543831 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543831 [ RunTime:0.002151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365556,395200,180858,600449,198226,195989,895178,103834,134277,322139,636382,657005,473316,613290,171852,636424,494733,798693,1029805,319330,546924,107994,695650,995573,921521,934424,654678,1013093,628614,442617,204759,1030511,309782,706588,547758,592998,142339,51454,500587,617745,997390,744679,152275,632175,1045629,497355,916268,392411,262713,804622,355727,958387,253538,210047,82542,815239,747017,835560,940830,357991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006731s ]